The Sales Rep table is available to be imported or exported as part of the system initialization process. Use this process to quickly build the tables in your system. The following fields are defined in this table. If a field is REQUIRED, it must be supplied as part of the import process.
Select Phase 2 - Sales Rep when importing/exporting Sales Rep type information.
Screen Label | Type | Alias Field | Req | Default | Possible Values | Table Alias |
Sales Rep | C 2 | SalesRepId | Yes | |||
Old Id | C 15 | Old_Id | ||||
Name | C 30 | Name | Yes | |||
Contact | C 30 | Contact | ||||
Address 1 | C 30 | Address1 | ||||
Address 2 | C 30 | Address2 | ||||
City | C 20 | City | ||||
State | C 2 | State | ||||
Zip | C 10 | Zip | ||||
Phone | C 14 | Phone | ||||
Fax | C 14 | Fax | ||||
Commissions | C 1 | Commission | N | Y,N | ||
Sales Order GP Calculation Method | C 1 | GpCalcMeth | O | O,A,S | ||
Commission only on Collected Sales | C 1 | Collected | Y | Y,N | ||
Exclude Accruals for Commissions | C 1 | Accruals | N | S,N,B,X | ||
Commission Expense Account | C 4 | Account | Account | |||
Commission Expense Cost Center | C 6 | CostCenter | Cost Center | |||
User Id | C 5 | User | User Security |
Security Required : Tables - Other Tables
See Also | Used In |